package com.example.victory.mapper;

import com.example.victory.entity.companyEntity.DeptAccountEntity;
import com.example.victory.entity.companyEntity.TxtjyrEntity;
import org.apache.ibatis.annotations.*;
import org.springframework.cache.annotation.CacheConfig;

import java.util.List;
import java.util.Map;

@Mapper
@CacheConfig(cacheNames = {"inner-business-customer"})
public interface DeptAndAccountMapper {


    @Select({"<script> select trim(LX) LX,trim(ND) ND,trim(YYB) YYB,trim(ZC) ZC,trim(JYL) JYL,trim(YJ) YJ  from CRM_APP.V_CCC_YYBKHGS  </script>"})
    List<DeptAccountEntity> findDept();


    @Select({"<script> select trim(LX) LX,trim(ND) ND,trim(GXLX) GXLX,trim(ZC) ZC,trim(RYID) RYID,trim(JYL) JYL,trim(YJ) YJ from CRM_APP.V_CCC_KHGS   </script>"})
    List<DeptAccountEntity> findAccount();


    @Select({"<script> select  *  from  his.txtjyr   </script>"})
    List<TxtjyrEntity> findTxtjyr();


}
